package com.desksoft.ecommerce.entity.mall.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.desksoft.ecommerce.base.Entity;

public class BankbillExample implements Entity{
    /**
	 * 
	 */
	private static final long serialVersionUID = -5225051797665992039L;

	protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BankbillExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBilllistIsNull() {
            addCriterion("BillList is null");
            return (Criteria) this;
        }

        public Criteria andBilllistIsNotNull() {
            addCriterion("BillList is not null");
            return (Criteria) this;
        }

        public Criteria andBilllistEqualTo(Long value) {
            addCriterion("BillList =", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotEqualTo(Long value) {
            addCriterion("BillList <>", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistGreaterThan(Long value) {
            addCriterion("BillList >", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistGreaterThanOrEqualTo(Long value) {
            addCriterion("BillList >=", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistLessThan(Long value) {
            addCriterion("BillList <", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistLessThanOrEqualTo(Long value) {
            addCriterion("BillList <=", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistIn(List<Long> values) {
            addCriterion("BillList in", values, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotIn(List<Long> values) {
            addCriterion("BillList not in", values, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistBetween(Long value1, Long value2) {
            addCriterion("BillList between", value1, value2, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotBetween(Long value1, Long value2) {
            addCriterion("BillList not between", value1, value2, "billlist");
            return (Criteria) this;
        }

        public Criteria andAcccodeIsNull() {
            addCriterion("AccCode is null");
            return (Criteria) this;
        }

        public Criteria andAcccodeIsNotNull() {
            addCriterion("AccCode is not null");
            return (Criteria) this;
        }

        public Criteria andAcccodeEqualTo(String value) {
            addCriterion("AccCode =", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeNotEqualTo(String value) {
            addCriterion("AccCode <>", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeGreaterThan(String value) {
            addCriterion("AccCode >", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeGreaterThanOrEqualTo(String value) {
            addCriterion("AccCode >=", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeLessThan(String value) {
            addCriterion("AccCode <", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeLessThanOrEqualTo(String value) {
            addCriterion("AccCode <=", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeLike(String value) {
            addCriterion("AccCode like", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeNotLike(String value) {
            addCriterion("AccCode not like", value, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeIn(List<String> values) {
            addCriterion("AccCode in", values, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeNotIn(List<String> values) {
            addCriterion("AccCode not in", values, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeBetween(String value1, String value2) {
            addCriterion("AccCode between", value1, value2, "acccode");
            return (Criteria) this;
        }

        public Criteria andAcccodeNotBetween(String value1, String value2) {
            addCriterion("AccCode not between", value1, value2, "acccode");
            return (Criteria) this;
        }

        public Criteria andWvIsNull() {
            addCriterion("WV is null");
            return (Criteria) this;
        }

        public Criteria andWvIsNotNull() {
            addCriterion("WV is not null");
            return (Criteria) this;
        }

        public Criteria andWvEqualTo(String value) {
            addCriterion("WV =", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvNotEqualTo(String value) {
            addCriterion("WV <>", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvGreaterThan(String value) {
            addCriterion("WV >", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvGreaterThanOrEqualTo(String value) {
            addCriterion("WV >=", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvLessThan(String value) {
            addCriterion("WV <", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvLessThanOrEqualTo(String value) {
            addCriterion("WV <=", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvLike(String value) {
            addCriterion("WV like", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvNotLike(String value) {
            addCriterion("WV not like", value, "wv");
            return (Criteria) this;
        }

        public Criteria andWvIn(List<String> values) {
            addCriterion("WV in", values, "wv");
            return (Criteria) this;
        }

        public Criteria andWvNotIn(List<String> values) {
            addCriterion("WV not in", values, "wv");
            return (Criteria) this;
        }

        public Criteria andWvBetween(String value1, String value2) {
            addCriterion("WV between", value1, value2, "wv");
            return (Criteria) this;
        }

        public Criteria andWvNotBetween(String value1, String value2) {
            addCriterion("WV not between", value1, value2, "wv");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNull() {
            addCriterion("SeqNo is null");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNotNull() {
            addCriterion("SeqNo is not null");
            return (Criteria) this;
        }

        public Criteria andSeqnoEqualTo(Integer value) {
            addCriterion("SeqNo =", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotEqualTo(Integer value) {
            addCriterion("SeqNo <>", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThan(Integer value) {
            addCriterion("SeqNo >", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("SeqNo >=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThan(Integer value) {
            addCriterion("SeqNo <", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThanOrEqualTo(Integer value) {
            addCriterion("SeqNo <=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoIn(List<Integer> values) {
            addCriterion("SeqNo in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotIn(List<Integer> values) {
            addCriterion("SeqNo not in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoBetween(Integer value1, Integer value2) {
            addCriterion("SeqNo between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotBetween(Integer value1, Integer value2) {
            addCriterion("SeqNo not between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andAccountcodeIsNull() {
            addCriterion("AccountCode is null");
            return (Criteria) this;
        }

        public Criteria andAccountcodeIsNotNull() {
            addCriterion("AccountCode is not null");
            return (Criteria) this;
        }

        public Criteria andAccountcodeEqualTo(String value) {
            addCriterion("AccountCode =", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeNotEqualTo(String value) {
            addCriterion("AccountCode <>", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeGreaterThan(String value) {
            addCriterion("AccountCode >", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeGreaterThanOrEqualTo(String value) {
            addCriterion("AccountCode >=", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeLessThan(String value) {
            addCriterion("AccountCode <", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeLessThanOrEqualTo(String value) {
            addCriterion("AccountCode <=", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeLike(String value) {
            addCriterion("AccountCode like", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeNotLike(String value) {
            addCriterion("AccountCode not like", value, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeIn(List<String> values) {
            addCriterion("AccountCode in", values, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeNotIn(List<String> values) {
            addCriterion("AccountCode not in", values, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeBetween(String value1, String value2) {
            addCriterion("AccountCode between", value1, value2, "accountcode");
            return (Criteria) this;
        }

        public Criteria andAccountcodeNotBetween(String value1, String value2) {
            addCriterion("AccountCode not between", value1, value2, "accountcode");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeIsNull() {
            addCriterion("BankBillType is null");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeIsNotNull() {
            addCriterion("BankBillType is not null");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeEqualTo(String value) {
            addCriterion("BankBillType =", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeNotEqualTo(String value) {
            addCriterion("BankBillType <>", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeGreaterThan(String value) {
            addCriterion("BankBillType >", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeGreaterThanOrEqualTo(String value) {
            addCriterion("BankBillType >=", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeLessThan(String value) {
            addCriterion("BankBillType <", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeLessThanOrEqualTo(String value) {
            addCriterion("BankBillType <=", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeLike(String value) {
            addCriterion("BankBillType like", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeNotLike(String value) {
            addCriterion("BankBillType not like", value, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeIn(List<String> values) {
            addCriterion("BankBillType in", values, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeNotIn(List<String> values) {
            addCriterion("BankBillType not in", values, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeBetween(String value1, String value2) {
            addCriterion("BankBillType between", value1, value2, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBankbilltypeNotBetween(String value1, String value2) {
            addCriterion("BankBillType not between", value1, value2, "bankbilltype");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNull() {
            addCriterion("BankName is null");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNotNull() {
            addCriterion("BankName is not null");
            return (Criteria) this;
        }

        public Criteria andBanknameEqualTo(String value) {
            addCriterion("BankName =", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotEqualTo(String value) {
            addCriterion("BankName <>", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThan(String value) {
            addCriterion("BankName >", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThanOrEqualTo(String value) {
            addCriterion("BankName >=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThan(String value) {
            addCriterion("BankName <", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThanOrEqualTo(String value) {
            addCriterion("BankName <=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLike(String value) {
            addCriterion("BankName like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotLike(String value) {
            addCriterion("BankName not like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameIn(List<String> values) {
            addCriterion("BankName in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotIn(List<String> values) {
            addCriterion("BankName not in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameBetween(String value1, String value2) {
            addCriterion("BankName between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotBetween(String value1, String value2) {
            addCriterion("BankName not between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andBankbillnoIsNull() {
            addCriterion("BankBillNo is null");
            return (Criteria) this;
        }

        public Criteria andBankbillnoIsNotNull() {
            addCriterion("BankBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBankbillnoEqualTo(String value) {
            addCriterion("BankBillNo =", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoNotEqualTo(String value) {
            addCriterion("BankBillNo <>", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoGreaterThan(String value) {
            addCriterion("BankBillNo >", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BankBillNo >=", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoLessThan(String value) {
            addCriterion("BankBillNo <", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoLessThanOrEqualTo(String value) {
            addCriterion("BankBillNo <=", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoLike(String value) {
            addCriterion("BankBillNo like", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoNotLike(String value) {
            addCriterion("BankBillNo not like", value, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoIn(List<String> values) {
            addCriterion("BankBillNo in", values, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoNotIn(List<String> values) {
            addCriterion("BankBillNo not in", values, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoBetween(String value1, String value2) {
            addCriterion("BankBillNo between", value1, value2, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbillnoNotBetween(String value1, String value2) {
            addCriterion("BankBillNo not between", value1, value2, "bankbillno");
            return (Criteria) this;
        }

        public Criteria andBankbilldateIsNull() {
            addCriterion("BankBillDate is null");
            return (Criteria) this;
        }

        public Criteria andBankbilldateIsNotNull() {
            addCriterion("BankBillDate is not null");
            return (Criteria) this;
        }

        public Criteria andBankbilldateEqualTo(Date value) {
            addCriterion("BankBillDate =", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateNotEqualTo(Date value) {
            addCriterion("BankBillDate <>", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateGreaterThan(Date value) {
            addCriterion("BankBillDate >", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateGreaterThanOrEqualTo(Date value) {
            addCriterion("BankBillDate >=", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateLessThan(Date value) {
            addCriterion("BankBillDate <", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateLessThanOrEqualTo(Date value) {
            addCriterion("BankBillDate <=", value, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateIn(List<Date> values) {
            addCriterion("BankBillDate in", values, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateNotIn(List<Date> values) {
            addCriterion("BankBillDate not in", values, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateBetween(Date value1, Date value2) {
            addCriterion("BankBillDate between", value1, value2, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldateNotBetween(Date value1, Date value2) {
            addCriterion("BankBillDate not between", value1, value2, "bankbilldate");
            return (Criteria) this;
        }

        public Criteria andBankbilldayIsNull() {
            addCriterion("BankBillDay is null");
            return (Criteria) this;
        }

        public Criteria andBankbilldayIsNotNull() {
            addCriterion("BankBillDay is not null");
            return (Criteria) this;
        }

        public Criteria andBankbilldayEqualTo(Integer value) {
            addCriterion("BankBillDay =", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayNotEqualTo(Integer value) {
            addCriterion("BankBillDay <>", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayGreaterThan(Integer value) {
            addCriterion("BankBillDay >", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayGreaterThanOrEqualTo(Integer value) {
            addCriterion("BankBillDay >=", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayLessThan(Integer value) {
            addCriterion("BankBillDay <", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayLessThanOrEqualTo(Integer value) {
            addCriterion("BankBillDay <=", value, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayIn(List<Integer> values) {
            addCriterion("BankBillDay in", values, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayNotIn(List<Integer> values) {
            addCriterion("BankBillDay not in", values, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayBetween(Integer value1, Integer value2) {
            addCriterion("BankBillDay between", value1, value2, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andBankbilldayNotBetween(Integer value1, Integer value2) {
            addCriterion("BankBillDay not between", value1, value2, "bankbillday");
            return (Criteria) this;
        }

        public Criteria andAmtIsNull() {
            addCriterion("Amt is null");
            return (Criteria) this;
        }

        public Criteria andAmtIsNotNull() {
            addCriterion("Amt is not null");
            return (Criteria) this;
        }

        public Criteria andAmtEqualTo(BigDecimal value) {
            addCriterion("Amt =", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotEqualTo(BigDecimal value) {
            addCriterion("Amt <>", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtGreaterThan(BigDecimal value) {
            addCriterion("Amt >", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Amt >=", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtLessThan(BigDecimal value) {
            addCriterion("Amt <", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Amt <=", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtIn(List<BigDecimal> values) {
            addCriterion("Amt in", values, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotIn(List<BigDecimal> values) {
            addCriterion("Amt not in", values, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amt between", value1, value2, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amt not between", value1, value2, "amt");
            return (Criteria) this;
        }

        public Criteria andAccountdateIsNull() {
            addCriterion("AccountDate is null");
            return (Criteria) this;
        }

        public Criteria andAccountdateIsNotNull() {
            addCriterion("AccountDate is not null");
            return (Criteria) this;
        }

        public Criteria andAccountdateEqualTo(Date value) {
            addCriterion("AccountDate =", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateNotEqualTo(Date value) {
            addCriterion("AccountDate <>", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateGreaterThan(Date value) {
            addCriterion("AccountDate >", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateGreaterThanOrEqualTo(Date value) {
            addCriterion("AccountDate >=", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateLessThan(Date value) {
            addCriterion("AccountDate <", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateLessThanOrEqualTo(Date value) {
            addCriterion("AccountDate <=", value, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateIn(List<Date> values) {
            addCriterion("AccountDate in", values, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateNotIn(List<Date> values) {
            addCriterion("AccountDate not in", values, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateBetween(Date value1, Date value2) {
            addCriterion("AccountDate between", value1, value2, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountdateNotBetween(Date value1, Date value2) {
            addCriterion("AccountDate not between", value1, value2, "accountdate");
            return (Criteria) this;
        }

        public Criteria andAccountflagIsNull() {
            addCriterion("AccountFlag is null");
            return (Criteria) this;
        }

        public Criteria andAccountflagIsNotNull() {
            addCriterion("AccountFlag is not null");
            return (Criteria) this;
        }

        public Criteria andAccountflagEqualTo(String value) {
            addCriterion("AccountFlag =", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagNotEqualTo(String value) {
            addCriterion("AccountFlag <>", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagGreaterThan(String value) {
            addCriterion("AccountFlag >", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagGreaterThanOrEqualTo(String value) {
            addCriterion("AccountFlag >=", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagLessThan(String value) {
            addCriterion("AccountFlag <", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagLessThanOrEqualTo(String value) {
            addCriterion("AccountFlag <=", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagLike(String value) {
            addCriterion("AccountFlag like", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagNotLike(String value) {
            addCriterion("AccountFlag not like", value, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagIn(List<String> values) {
            addCriterion("AccountFlag in", values, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagNotIn(List<String> values) {
            addCriterion("AccountFlag not in", values, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagBetween(String value1, String value2) {
            addCriterion("AccountFlag between", value1, value2, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccountflagNotBetween(String value1, String value2) {
            addCriterion("AccountFlag not between", value1, value2, "accountflag");
            return (Criteria) this;
        }

        public Criteria andAccounterIsNull() {
            addCriterion("Accounter is null");
            return (Criteria) this;
        }

        public Criteria andAccounterIsNotNull() {
            addCriterion("Accounter is not null");
            return (Criteria) this;
        }

        public Criteria andAccounterEqualTo(String value) {
            addCriterion("Accounter =", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterNotEqualTo(String value) {
            addCriterion("Accounter <>", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterGreaterThan(String value) {
            addCriterion("Accounter >", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterGreaterThanOrEqualTo(String value) {
            addCriterion("Accounter >=", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterLessThan(String value) {
            addCriterion("Accounter <", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterLessThanOrEqualTo(String value) {
            addCriterion("Accounter <=", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterLike(String value) {
            addCriterion("Accounter like", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterNotLike(String value) {
            addCriterion("Accounter not like", value, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterIn(List<String> values) {
            addCriterion("Accounter in", values, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterNotIn(List<String> values) {
            addCriterion("Accounter not in", values, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterBetween(String value1, String value2) {
            addCriterion("Accounter between", value1, value2, "accounter");
            return (Criteria) this;
        }

        public Criteria andAccounterNotBetween(String value1, String value2) {
            addCriterion("Accounter not between", value1, value2, "accounter");
            return (Criteria) this;
        }

        public Criteria andGuarantorIsNull() {
            addCriterion("Guarantor is null");
            return (Criteria) this;
        }

        public Criteria andGuarantorIsNotNull() {
            addCriterion("Guarantor is not null");
            return (Criteria) this;
        }

        public Criteria andGuarantorEqualTo(String value) {
            addCriterion("Guarantor =", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorNotEqualTo(String value) {
            addCriterion("Guarantor <>", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorGreaterThan(String value) {
            addCriterion("Guarantor >", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorGreaterThanOrEqualTo(String value) {
            addCriterion("Guarantor >=", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorLessThan(String value) {
            addCriterion("Guarantor <", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorLessThanOrEqualTo(String value) {
            addCriterion("Guarantor <=", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorLike(String value) {
            addCriterion("Guarantor like", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorNotLike(String value) {
            addCriterion("Guarantor not like", value, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorIn(List<String> values) {
            addCriterion("Guarantor in", values, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorNotIn(List<String> values) {
            addCriterion("Guarantor not in", values, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorBetween(String value1, String value2) {
            addCriterion("Guarantor between", value1, value2, "guarantor");
            return (Criteria) this;
        }

        public Criteria andGuarantorNotBetween(String value1, String value2) {
            addCriterion("Guarantor not between", value1, value2, "guarantor");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCasherIsNull() {
            addCriterion("Casher is null");
            return (Criteria) this;
        }

        public Criteria andCasherIsNotNull() {
            addCriterion("Casher is not null");
            return (Criteria) this;
        }

        public Criteria andCasherEqualTo(String value) {
            addCriterion("Casher =", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherNotEqualTo(String value) {
            addCriterion("Casher <>", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherGreaterThan(String value) {
            addCriterion("Casher >", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherGreaterThanOrEqualTo(String value) {
            addCriterion("Casher >=", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherLessThan(String value) {
            addCriterion("Casher <", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherLessThanOrEqualTo(String value) {
            addCriterion("Casher <=", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherLike(String value) {
            addCriterion("Casher like", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherNotLike(String value) {
            addCriterion("Casher not like", value, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherIn(List<String> values) {
            addCriterion("Casher in", values, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherNotIn(List<String> values) {
            addCriterion("Casher not in", values, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherBetween(String value1, String value2) {
            addCriterion("Casher between", value1, value2, "casher");
            return (Criteria) this;
        }

        public Criteria andCasherNotBetween(String value1, String value2) {
            addCriterion("Casher not between", value1, value2, "casher");
            return (Criteria) this;
        }

        public Criteria andCashflagIsNull() {
            addCriterion("CashFlag is null");
            return (Criteria) this;
        }

        public Criteria andCashflagIsNotNull() {
            addCriterion("CashFlag is not null");
            return (Criteria) this;
        }

        public Criteria andCashflagEqualTo(String value) {
            addCriterion("CashFlag =", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagNotEqualTo(String value) {
            addCriterion("CashFlag <>", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagGreaterThan(String value) {
            addCriterion("CashFlag >", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagGreaterThanOrEqualTo(String value) {
            addCriterion("CashFlag >=", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagLessThan(String value) {
            addCriterion("CashFlag <", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagLessThanOrEqualTo(String value) {
            addCriterion("CashFlag <=", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagLike(String value) {
            addCriterion("CashFlag like", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagNotLike(String value) {
            addCriterion("CashFlag not like", value, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagIn(List<String> values) {
            addCriterion("CashFlag in", values, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagNotIn(List<String> values) {
            addCriterion("CashFlag not in", values, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagBetween(String value1, String value2) {
            addCriterion("CashFlag between", value1, value2, "cashflag");
            return (Criteria) this;
        }

        public Criteria andCashflagNotBetween(String value1, String value2) {
            addCriterion("CashFlag not between", value1, value2, "cashflag");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNull() {
            addCriterion("DCCode is null");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNotNull() {
            addCriterion("DCCode is not null");
            return (Criteria) this;
        }

        public Criteria andDccodeEqualTo(String value) {
            addCriterion("DCCode =", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotEqualTo(String value) {
            addCriterion("DCCode <>", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThan(String value) {
            addCriterion("DCCode >", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThanOrEqualTo(String value) {
            addCriterion("DCCode >=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThan(String value) {
            addCriterion("DCCode <", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThanOrEqualTo(String value) {
            addCriterion("DCCode <=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLike(String value) {
            addCriterion("DCCode like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotLike(String value) {
            addCriterion("DCCode not like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeIn(List<String> values) {
            addCriterion("DCCode in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotIn(List<String> values) {
            addCriterion("DCCode not in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeBetween(String value1, String value2) {
            addCriterion("DCCode between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotBetween(String value1, String value2) {
            addCriterion("DCCode not between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNull() {
            addCriterion("BillMode is null");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNotNull() {
            addCriterion("BillMode is not null");
            return (Criteria) this;
        }

        public Criteria andBillmodeEqualTo(String value) {
            addCriterion("BillMode =", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotEqualTo(String value) {
            addCriterion("BillMode <>", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThan(String value) {
            addCriterion("BillMode >", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThanOrEqualTo(String value) {
            addCriterion("BillMode >=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThan(String value) {
            addCriterion("BillMode <", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThanOrEqualTo(String value) {
            addCriterion("BillMode <=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLike(String value) {
            addCriterion("BillMode like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotLike(String value) {
            addCriterion("BillMode not like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIn(List<String> values) {
            addCriterion("BillMode in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotIn(List<String> values) {
            addCriterion("BillMode not in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeBetween(String value1, String value2) {
            addCriterion("BillMode between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotBetween(String value1, String value2) {
            addCriterion("BillMode not between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andVipcardnoIsNull() {
            addCriterion("VipCardNo is null");
            return (Criteria) this;
        }

        public Criteria andVipcardnoIsNotNull() {
            addCriterion("VipCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andVipcardnoEqualTo(String value) {
            addCriterion("VipCardNo =", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoNotEqualTo(String value) {
            addCriterion("VipCardNo <>", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoGreaterThan(String value) {
            addCriterion("VipCardNo >", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("VipCardNo >=", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoLessThan(String value) {
            addCriterion("VipCardNo <", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoLessThanOrEqualTo(String value) {
            addCriterion("VipCardNo <=", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoLike(String value) {
            addCriterion("VipCardNo like", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoNotLike(String value) {
            addCriterion("VipCardNo not like", value, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoIn(List<String> values) {
            addCriterion("VipCardNo in", values, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoNotIn(List<String> values) {
            addCriterion("VipCardNo not in", values, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoBetween(String value1, String value2) {
            addCriterion("VipCardNo between", value1, value2, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andVipcardnoNotBetween(String value1, String value2) {
            addCriterion("VipCardNo not between", value1, value2, "vipcardno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("OrderNo =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("OrderNo <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("OrderNo >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("OrderNo >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("OrderNo <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("OrderNo <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("OrderNo like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("OrderNo not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("OrderNo in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("OrderNo not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("OrderNo between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("OrderNo not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andBankbilllistIsNull() {
            addCriterion("BankBillList is null");
            return (Criteria) this;
        }

        public Criteria andBankbilllistIsNotNull() {
            addCriterion("BankBillList is not null");
            return (Criteria) this;
        }

        public Criteria andBankbilllistEqualTo(Long value) {
            addCriterion("BankBillList =", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistNotEqualTo(Long value) {
            addCriterion("BankBillList <>", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistGreaterThan(Long value) {
            addCriterion("BankBillList >", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistGreaterThanOrEqualTo(Long value) {
            addCriterion("BankBillList >=", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistLessThan(Long value) {
            addCriterion("BankBillList <", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistLessThanOrEqualTo(Long value) {
            addCriterion("BankBillList <=", value, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistIn(List<Long> values) {
            addCriterion("BankBillList in", values, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistNotIn(List<Long> values) {
            addCriterion("BankBillList not in", values, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistBetween(Long value1, Long value2) {
            addCriterion("BankBillList between", value1, value2, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andBankbilllistNotBetween(Long value1, Long value2) {
            addCriterion("BankBillList not between", value1, value2, "bankbilllist");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("Fee is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("Fee is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(BigDecimal value) {
            addCriterion("Fee =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(BigDecimal value) {
            addCriterion("Fee <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(BigDecimal value) {
            addCriterion("Fee >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(BigDecimal value) {
            addCriterion("Fee <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<BigDecimal> values) {
            addCriterion("Fee in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<BigDecimal> values) {
            addCriterion("Fee not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andCancelmanIsNull() {
            addCriterion("CancelMan is null");
            return (Criteria) this;
        }

        public Criteria andCancelmanIsNotNull() {
            addCriterion("CancelMan is not null");
            return (Criteria) this;
        }

        public Criteria andCancelmanEqualTo(String value) {
            addCriterion("CancelMan =", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanNotEqualTo(String value) {
            addCriterion("CancelMan <>", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanGreaterThan(String value) {
            addCriterion("CancelMan >", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanGreaterThanOrEqualTo(String value) {
            addCriterion("CancelMan >=", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanLessThan(String value) {
            addCriterion("CancelMan <", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanLessThanOrEqualTo(String value) {
            addCriterion("CancelMan <=", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanLike(String value) {
            addCriterion("CancelMan like", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanNotLike(String value) {
            addCriterion("CancelMan not like", value, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanIn(List<String> values) {
            addCriterion("CancelMan in", values, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanNotIn(List<String> values) {
            addCriterion("CancelMan not in", values, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanBetween(String value1, String value2) {
            addCriterion("CancelMan between", value1, value2, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCancelmanNotBetween(String value1, String value2) {
            addCriterion("CancelMan not between", value1, value2, "cancelman");
            return (Criteria) this;
        }

        public Criteria andCanceldateIsNull() {
            addCriterion("CancelDate is null");
            return (Criteria) this;
        }

        public Criteria andCanceldateIsNotNull() {
            addCriterion("CancelDate is not null");
            return (Criteria) this;
        }

        public Criteria andCanceldateEqualTo(Date value) {
            addCriterion("CancelDate =", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotEqualTo(Date value) {
            addCriterion("CancelDate <>", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateGreaterThan(Date value) {
            addCriterion("CancelDate >", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateGreaterThanOrEqualTo(Date value) {
            addCriterion("CancelDate >=", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateLessThan(Date value) {
            addCriterion("CancelDate <", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateLessThanOrEqualTo(Date value) {
            addCriterion("CancelDate <=", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateIn(List<Date> values) {
            addCriterion("CancelDate in", values, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotIn(List<Date> values) {
            addCriterion("CancelDate not in", values, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateBetween(Date value1, Date value2) {
            addCriterion("CancelDate between", value1, value2, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotBetween(Date value1, Date value2) {
            addCriterion("CancelDate not between", value1, value2, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCancelmemoIsNull() {
            addCriterion("CancelMemo is null");
            return (Criteria) this;
        }

        public Criteria andCancelmemoIsNotNull() {
            addCriterion("CancelMemo is not null");
            return (Criteria) this;
        }

        public Criteria andCancelmemoEqualTo(String value) {
            addCriterion("CancelMemo =", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoNotEqualTo(String value) {
            addCriterion("CancelMemo <>", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoGreaterThan(String value) {
            addCriterion("CancelMemo >", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoGreaterThanOrEqualTo(String value) {
            addCriterion("CancelMemo >=", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoLessThan(String value) {
            addCriterion("CancelMemo <", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoLessThanOrEqualTo(String value) {
            addCriterion("CancelMemo <=", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoLike(String value) {
            addCriterion("CancelMemo like", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoNotLike(String value) {
            addCriterion("CancelMemo not like", value, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoIn(List<String> values) {
            addCriterion("CancelMemo in", values, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoNotIn(List<String> values) {
            addCriterion("CancelMemo not in", values, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoBetween(String value1, String value2) {
            addCriterion("CancelMemo between", value1, value2, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andCancelmemoNotBetween(String value1, String value2) {
            addCriterion("CancelMemo not between", value1, value2, "cancelmemo");
            return (Criteria) this;
        }

        public Criteria andInputdateIsNull() {
            addCriterion("InputDate is null");
            return (Criteria) this;
        }

        public Criteria andInputdateIsNotNull() {
            addCriterion("InputDate is not null");
            return (Criteria) this;
        }

        public Criteria andInputdateEqualTo(Date value) {
            addCriterion("InputDate =", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateNotEqualTo(Date value) {
            addCriterion("InputDate <>", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateGreaterThan(Date value) {
            addCriterion("InputDate >", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateGreaterThanOrEqualTo(Date value) {
            addCriterion("InputDate >=", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateLessThan(Date value) {
            addCriterion("InputDate <", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateLessThanOrEqualTo(Date value) {
            addCriterion("InputDate <=", value, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateIn(List<Date> values) {
            addCriterion("InputDate in", values, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateNotIn(List<Date> values) {
            addCriterion("InputDate not in", values, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateBetween(Date value1, Date value2) {
            addCriterion("InputDate between", value1, value2, "inputdate");
            return (Criteria) this;
        }

        public Criteria andInputdateNotBetween(Date value1, Date value2) {
            addCriterion("InputDate not between", value1, value2, "inputdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIsNull() {
            addCriterion("ConfirmDate is null");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIsNotNull() {
            addCriterion("ConfirmDate is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmdateEqualTo(Date value) {
            addCriterion("ConfirmDate =", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotEqualTo(Date value) {
            addCriterion("ConfirmDate <>", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateGreaterThan(Date value) {
            addCriterion("ConfirmDate >", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateGreaterThanOrEqualTo(Date value) {
            addCriterion("ConfirmDate >=", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateLessThan(Date value) {
            addCriterion("ConfirmDate <", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateLessThanOrEqualTo(Date value) {
            addCriterion("ConfirmDate <=", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIn(List<Date> values) {
            addCriterion("ConfirmDate in", values, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotIn(List<Date> values) {
            addCriterion("ConfirmDate not in", values, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateBetween(Date value1, Date value2) {
            addCriterion("ConfirmDate between", value1, value2, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotBetween(Date value1, Date value2) {
            addCriterion("ConfirmDate not between", value1, value2, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateIsNull() {
            addCriterion("TurnBalanceDate is null");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateIsNotNull() {
            addCriterion("TurnBalanceDate is not null");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateEqualTo(Date value) {
            addCriterion("TurnBalanceDate =", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateNotEqualTo(Date value) {
            addCriterion("TurnBalanceDate <>", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateGreaterThan(Date value) {
            addCriterion("TurnBalanceDate >", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateGreaterThanOrEqualTo(Date value) {
            addCriterion("TurnBalanceDate >=", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateLessThan(Date value) {
            addCriterion("TurnBalanceDate <", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateLessThanOrEqualTo(Date value) {
            addCriterion("TurnBalanceDate <=", value, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateIn(List<Date> values) {
            addCriterion("TurnBalanceDate in", values, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateNotIn(List<Date> values) {
            addCriterion("TurnBalanceDate not in", values, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateBetween(Date value1, Date value2) {
            addCriterion("TurnBalanceDate between", value1, value2, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancedateNotBetween(Date value1, Date value2) {
            addCriterion("TurnBalanceDate not between", value1, value2, "turnbalancedate");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanIsNull() {
            addCriterion("TurnBalanceMan is null");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanIsNotNull() {
            addCriterion("TurnBalanceMan is not null");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanEqualTo(String value) {
            addCriterion("TurnBalanceMan =", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanNotEqualTo(String value) {
            addCriterion("TurnBalanceMan <>", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanGreaterThan(String value) {
            addCriterion("TurnBalanceMan >", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanGreaterThanOrEqualTo(String value) {
            addCriterion("TurnBalanceMan >=", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanLessThan(String value) {
            addCriterion("TurnBalanceMan <", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanLessThanOrEqualTo(String value) {
            addCriterion("TurnBalanceMan <=", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanLike(String value) {
            addCriterion("TurnBalanceMan like", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanNotLike(String value) {
            addCriterion("TurnBalanceMan not like", value, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanIn(List<String> values) {
            addCriterion("TurnBalanceMan in", values, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanNotIn(List<String> values) {
            addCriterion("TurnBalanceMan not in", values, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanBetween(String value1, String value2) {
            addCriterion("TurnBalanceMan between", value1, value2, "turnbalanceman");
            return (Criteria) this;
        }

        public Criteria andTurnbalancemanNotBetween(String value1, String value2) {
            addCriterion("TurnBalanceMan not between", value1, value2, "turnbalanceman");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}